package com.cs.beneficios.web.action;

import com.cs.beneficios.business.entity.SedeDAO;
import com.cs.beneficios.common.ConnectionFactory;

import java.io.IOException;

import java.sql.SQLException;

import java.util.Collection;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

public class SedesAsociadasAction extends Action {
	/**This is the main action called from the Struts framework.
	 * @param mapping The ActionMapping used to select this instance.
	 * @param form The optional ActionForm bean for this request.
	 * @param request The HTTP Request we are processing.
	 * @param response The HTTP Response we are processing.
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form, 
								 HttpServletRequest request, 
								 HttpServletResponse response) throws IOException, 
																	  ServletException {
                                                                      
		ConnectionFactory cf = new ConnectionFactory();
		Collection sedes = null;
		String codigoSubprograma = request.getParameter("Codigo");
		SedeDAO sedeDAO = new SedeDAO(cf);

		try {
			sedes = sedeDAO.getSedesAsociadas(codigoSubprograma);
			request.setAttribute("sedes", sedes);
		} catch (SQLException e) {
			System.err.println("/******** TDSUB - cwsub");
			e.printStackTrace();
			System.err.println("TDSUB - cwsub ********/");
		}
        
		return mapping.findForward( "success");
	}
}
